The OPTION keyword denotes options the user can pass in with the command. These options are Teiid specific and not covered by any SQL specification.

Usage:

OPTION option, (option)*

Supported options:

• MAKEDEP table [(,table)*] - specifies source tables that should be made dependent in the join

• MAKENOTDEP table [(,table)*] - prevents a dependent join from being used

• NOCACHE [table (,table)*] - prevents cache from being used for all tables or for the given tables

Examples:

• OPTION MAKEDEP table1

• OPTION NOCACHE

All tables specified in the OPTION clause should be fully qualified, however the name may match either an alias name or the fully qualified name.